home *** CD-ROM | disk | FTP | other *** search
- INDEX
- Returns the value of the cell whose position is determined by the row and column offsets from the first cell specified in the range argument.
-
- Format: INDEX (range, row, column)
-
- Arguments:
- ΓÇó range: A cell range of one or more rows.
- ΓÇó row: A number or numeric expression whose value is within the range specified.
- ΓÇó column: A number or numeric expression whose value is within the range specified.
-
- Example:
- INDEX (B1..D5, 3,2) returns 12.
- Shows that the number 12 is in the cell that is in the third cell down and the second row over from B1 (the start of the range).